<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" /><title>JdbcUtilsTest xref</title>
<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../../../../../../../apidocs/org/sakaiproject/genericdao/springjdbc/JdbcUtilsTest.html">View Javadoc</a></div><pre>

<a name="1" href="#1">1</a>   <em>/**<em>*</em></em>
<a name="2" href="#2">2</a>   <em> * $Id: JdbcUtilsTest.html 11 2009-01-29 14:58:33Z azeckoski $</em>
<a name="3" href="#3">3</a>   <em> * $URL: http://genericdao.googlecode.com/svn/maven/site/xref-test/org/sakaiproject/genericdao/springjdbc/JdbcUtilsTest.html $</em>
<a name="4" href="#4">4</a>   <em> * JdbcUtils.java - genericdao - May 9, 2008 11:43:06 AM - azeckoski</em>
<a name="5" href="#5">5</a>   <em> **************************************************************************</em>
<a name="6" href="#6">6</a>   <em> * Copyright (c) 2008 Aaron Zeckoski</em>
<a name="7" href="#7">7</a>   <em> * Licensed under the Apache License, Version 2.0</em>
<a name="8" href="#8">8</a>   <em> * </em>
<a name="9" href="#9">9</a>   <em> * A copy of the Apache License has been included in this </em>
<a name="10" href="#10">10</a>  <em> * distribution and is available at: <a href="http://www.apache.org/licenses/LICENSE-2.0.txt" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0.txt</a></em>
<a name="11" href="#11">11</a>  <em> *</em>
<a name="12" href="#12">12</a>  <em> * Aaron Zeckoski (azeckoski@gmail.com) (aaronz@vt.edu) (aaron@caret.cam.ac.uk)</em>
<a name="13" href="#13">13</a>  <em> */</em>
<a name="14" href="#14">14</a>  
<a name="15" href="#15">15</a>  <strong>package</strong> org.sakaiproject.genericdao.springjdbc;
<a name="16" href="#16">16</a>  
<a name="17" href="#17">17</a>  <strong>import</strong> java.util.ArrayList;
<a name="18" href="#18">18</a>  <strong>import</strong> java.util.HashMap;
<a name="19" href="#19">19</a>  <strong>import</strong> java.util.List;
<a name="20" href="#20">20</a>  <strong>import</strong> java.util.Map;
<a name="21" href="#21">21</a>  
<a name="22" href="#22">22</a>  <strong>import</strong> org.sakaiproject.genericdao.api.mappers.DataMapper;
<a name="23" href="#23">23</a>  <strong>import</strong> org.sakaiproject.genericdao.test.GenericTestObject;
<a name="24" href="#24">24</a>  <strong>import</strong> org.sakaiproject.genericdao.test.GenericTestParentObject;
<a name="25" href="#25">25</a>  
<a name="26" href="#26">26</a>  <strong>import</strong> junit.framework.TestCase;
<a name="27" href="#27">27</a>  
<a name="28" href="#28">28</a>  
<a name="29" href="#29">29</a>  <em>/**<em>*</em></em>
<a name="30" href="#30">30</a>  <em> * Testing the utility methods used in JdbcGenericDao</em>
<a name="31" href="#31">31</a>  <em> * </em>
<a name="32" href="#32">32</a>  <em> * @author Aaron Zeckoski (azeckoski@gmail.com)</em>
<a name="33" href="#33">33</a>  <em> */</em>
<a name="34" href="#34">34</a>  <strong>public</strong> <strong>class</strong> <a href="../../../../org/sakaiproject/genericdao/springjdbc/JdbcUtilsTest.html">JdbcUtilsTest</a> <strong>extends</strong> TestCase {
<a name="35" href="#35">35</a>  
<a name="36" href="#36">36</a>     JdbcGenericDao dao;
<a name="37" href="#37">37</a>  
<a name="38" href="#38">38</a>     @Override
<a name="39" href="#39">39</a>     <strong>protected</strong> <strong>void</strong> setUp() throws Exception {
<a name="40" href="#40">40</a>        <strong>super</strong>.setUp();
<a name="41" href="#41">41</a>  
<a name="42" href="#42">42</a>        dao = <strong>new</strong> JdbcGenericDao();
<a name="43" href="#43">43</a>        List&lt;DataMapper> mappers = <strong>new</strong> ArrayList&lt;DataMapper>();
<a name="44" href="#44">44</a>        mappers.add( <strong>new</strong> GTODataMapper() );
<a name="45" href="#45">45</a>        mappers.add( <strong>new</strong> SimpleDataMapper(GenericTestParentObject.<strong>class</strong>) );
<a name="46" href="#46">46</a>        dao.setDataMappers(mappers);
<a name="47" href="#47">47</a>     }
<a name="48" href="#48">48</a>  
<a name="49" href="#49">49</a>     <em>/**<em>*</em></em>
<a name="50" href="#50">50</a>  <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#setDatabaseType(java.lang.String)}.</em>
<a name="51" href="#51">51</a>  <em>    */</em>
<a name="52" href="#52">52</a>     <strong>public</strong> <strong>void</strong> testSetDatabaseType() {
<a name="53" href="#53">53</a>        dao.setDatabaseType(<span class="string">"mysql"</span>);
<a name="54" href="#54">54</a>        assertEquals(<span class="string">"MYSQL"</span>, dao.getDatabaseType());
<a name="55" href="#55">55</a>  
<a name="56" href="#56">56</a>        dao.setDatabaseType(<span class="string">"Oracle"</span>);
<a name="57" href="#57">57</a>        assertEquals(<span class="string">"ORACLE"</span>, dao.getDatabaseType());
<a name="58" href="#58">58</a>  
<a name="59" href="#59">59</a>        dao.setDatabaseType(<span class="string">"MSSQL"</span>);
<a name="60" href="#60">60</a>        assertEquals(<span class="string">"MSSQL"</span>, dao.getDatabaseType());
<a name="61" href="#61">61</a>  
<a name="62" href="#62">62</a>        <strong>try</strong> {
<a name="63" href="#63">63</a>           dao.setDatabaseType(<strong>null</strong>);
<a name="64" href="#64">64</a>           fail(<span class="string">"Should have thrown exception"</span>);
<a name="65" href="#65">65</a>        } <strong>catch</strong> (IllegalArgumentException e) {
<a name="66" href="#66">66</a>           assertNotNull(e);
<a name="67" href="#67">67</a>        }
<a name="68" href="#68">68</a>     }
<a name="69" href="#69">69</a>  
<a name="70" href="#70">70</a>     <em>/**<em>*</em></em>
<a name="71" href="#71">71</a>  <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#getTableNameFromClass(java.lang.Class)}.</em>
<a name="72" href="#72">72</a>  <em>    */</em>
<a name="73" href="#73">73</a>     <strong>public</strong> <strong>void</strong> testGetTableNameFromClass() {
<a name="74" href="#74">74</a>        String tableName = <strong>null</strong>;
<a name="75" href="#75">75</a>  
<a name="76" href="#76">76</a>        tableName = dao.getTableNameFromClass(GenericTestObject.<strong>class</strong>);
<a name="77" href="#77">77</a>        assertEquals(<span class="string">"MY_GENERIC_TEST_OBJECT"</span>, tableName);
<a name="78" href="#78">78</a>  
<a name="79" href="#79">79</a>        tableName = dao.getTableNameFromClass(GenericTestParentObject.<strong>class</strong>);
<a name="80" href="#80">80</a>        assertEquals(<span class="string">"GENERIC_TEST_PARENT_OBJECT"</span>, tableName);
<a name="81" href="#81">81</a>  
<a name="82" href="#82">82</a>        <strong>try</strong> {
<a name="83" href="#83">83</a>           tableName = dao.getTableNameFromClass(String.<strong>class</strong>);
<a name="84" href="#84">84</a>           fail(<span class="string">"Should have thrown exception"</span>);
<a name="85" href="#85">85</a>        } <strong>catch</strong> (IllegalArgumentException e) {
<a name="86" href="#86">86</a>           assertNotNull(e);
<a name="87" href="#87">87</a>        }
<a name="88" href="#88">88</a>     }
<a name="89" href="#89">89</a>  
<a name="90" href="#90">90</a>     <em>/**<em>*</em></em>
<a name="91" href="#91">91</a>  <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#makeEntityFromMap(java.lang.Class, java.util.Map)}.</em>
<a name="92" href="#92">92</a>  <em>    */</em>
<a name="93" href="#93">93</a>     <strong>public</strong> <strong>void</strong> testMakeEntityFromMap() {
<a name="94" href="#94">94</a>        Map&lt;String, Object> data = <strong>new</strong> HashMap&lt;String, Object>();
<a name="95" href="#95">95</a>        data.put(<span class="string">"GTO_ID"</span>, <strong>new</strong> Long(10));
<a name="96" href="#96">96</a>        data.put(<span class="string">"GTO_TITLE"</span>, <span class="string">"TEST"</span>);
<a name="97" href="#97">97</a>        data.put(<span class="string">"GTO_HIDDEN"</span>, false);
<a name="98" href="#98">98</a>  
<a name="99" href="#99">99</a>        <a href="../../../../org/sakaiproject/genericdao/test/GenericTestObject.html">GenericTestObject</a> gto = dao.makeEntityFromMap(GenericTestObject.<strong>class</strong>, data);
<a name="100" href="#100">100</a>       assertNotNull(gto);
<a name="101" href="#101">101</a>       assertEquals(<strong>new</strong> Long(10), gto.getId());
<a name="102" href="#102">102</a>       assertEquals(<span class="string">"TEST"</span>, gto.getTitle());
<a name="103" href="#103">103</a>       assertEquals(Boolean.FALSE, gto.getHiddenItem());
<a name="104" href="#104">104</a> 
<a name="105" href="#105">105</a>       data = <strong>new</strong> HashMap&lt;String, Object>();
<a name="106" href="#106">106</a>       data.put(<span class="string">"UID"</span>, <strong>new</strong> Long(50));
<a name="107" href="#107">107</a>       data.put(<span class="string">"TITLE"</span>, <span class="string">"TESTING"</span>);
<a name="108" href="#108">108</a>       data.put(<span class="string">"GTO"</span>, <strong>new</strong> Long(100));
<a name="109" href="#109">109</a> 
<a name="110" href="#110">110</a>       <a href="../../../../org/sakaiproject/genericdao/test/GenericTestParentObject.html">GenericTestParentObject</a> gtpo = dao.makeEntityFromMap(GenericTestParentObject.<strong>class</strong>, data);
<a name="111" href="#111">111</a>       assertNotNull(gtpo);
<a name="112" href="#112">112</a>       assertEquals(<strong>new</strong> Long(50), gtpo.getUid());
<a name="113" href="#113">113</a>       assertEquals(<span class="string">"TESTING"</span>, gtpo.getTitle());
<a name="114" href="#114">114</a>       assertNotNull(gtpo.getGto());
<a name="115" href="#115">115</a>       assertEquals(<strong>new</strong> Long(100), gtpo.getGto().getId());
<a name="116" href="#116">116</a> 
<a name="117" href="#117">117</a>    }
<a name="118" href="#118">118</a> 
<a name="119" href="#119">119</a>    <em>/**<em>*</em></em>
<a name="120" href="#120">120</a> <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#makeMapFromEntity(java.lang.Object)}.</em>
<a name="121" href="#121">121</a> <em>    */</em>
<a name="122" href="#122">122</a>    <strong>public</strong> <strong>void</strong> testMakeMapFromEntity() {
<a name="123" href="#123">123</a>       <a href="../../../../org/sakaiproject/genericdao/test/GenericTestObject.html">GenericTestObject</a> gto = <strong>new</strong> <a href="../../../../org/sakaiproject/genericdao/test/GenericTestObject.html">GenericTestObject</a>(<span class="string">"TEST"</span>, false);
<a name="124" href="#124">124</a>       gto.setId( <strong>new</strong> Long(10) );
<a name="125" href="#125">125</a> 
<a name="126" href="#126">126</a>       Map&lt;String, Object> data = dao.makeMapFromEntity(gto);
<a name="127" href="#127">127</a>       assertNotNull(data);
<a name="128" href="#128">128</a>       assertEquals(<strong>new</strong> Long(10), data.get(<span class="string">"GTO_ID"</span>));
<a name="129" href="#129">129</a>       assertEquals(<span class="string">"TEST"</span>, data.get(<span class="string">"GTO_TITLE"</span>));
<a name="130" href="#130">130</a>       assertEquals(false, data.get(<span class="string">"GTO_HIDDEN"</span>));
<a name="131" href="#131">131</a> 
<a name="132" href="#132">132</a>       <a href="../../../../org/sakaiproject/genericdao/test/GenericTestParentObject.html">GenericTestParentObject</a> gtpo = <strong>new</strong> <a href="../../../../org/sakaiproject/genericdao/test/GenericTestParentObject.html">GenericTestParentObject</a>(<span class="string">"TESTING"</span>, gto);
<a name="133" href="#133">133</a>       gtpo.setUid( <strong>new</strong> Long(100) );
<a name="134" href="#134">134</a> 
<a name="135" href="#135">135</a>       data = dao.makeMapFromEntity(gtpo);
<a name="136" href="#136">136</a>       assertNotNull(data);
<a name="137" href="#137">137</a>       assertEquals(<strong>new</strong> Long(100), data.get(<span class="string">"UID"</span>));
<a name="138" href="#138">138</a>       assertEquals(<span class="string">"TESTING"</span>, data.get(<span class="string">"TITLE"</span>));
<a name="139" href="#139">139</a>       assertNotNull(data.get(<span class="string">"GTO"</span>));
<a name="140" href="#140">140</a>       assertEquals(<strong>new</strong> Long(10), data.get(<span class="string">"GTO"</span>) );
<a name="141" href="#141">141</a>    }
<a name="142" href="#142">142</a> 
<a name="143" href="#143">143</a>    <em>/**<em>*</em></em>
<a name="144" href="#144">144</a> <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#getIdValue(java.lang.Object)}.</em>
<a name="145" href="#145">145</a> <em>    */</em>
<a name="146" href="#146">146</a>    <strong>public</strong> <strong>void</strong> testGetIdValue() {
<a name="147" href="#147">147</a>       <a href="../../../../org/sakaiproject/genericdao/test/GenericTestObject.html">GenericTestObject</a> gto = <strong>new</strong> <a href="../../../../org/sakaiproject/genericdao/test/GenericTestObject.html">GenericTestObject</a>();
<a name="148" href="#148">148</a>       gto.setId( <strong>new</strong> Long(100) );
<a name="149" href="#149">149</a>       Object value = dao.getIdValue(gto);
<a name="150" href="#150">150</a>       assertNotNull(value);
<a name="151" href="#151">151</a>       assertEquals(<strong>new</strong> Long(100), value);
<a name="152" href="#152">152</a> 
<a name="153" href="#153">153</a>       <a href="../../../../org/sakaiproject/genericdao/test/GenericTestParentObject.html">GenericTestParentObject</a> gtpo = <strong>new</strong> <a href="../../../../org/sakaiproject/genericdao/test/GenericTestParentObject.html">GenericTestParentObject</a>();
<a name="154" href="#154">154</a>       gtpo.setUid( <strong>new</strong> Long(555) );
<a name="155" href="#155">155</a>       value = dao.getIdValue(gtpo);
<a name="156" href="#156">156</a>       assertNotNull(value);
<a name="157" href="#157">157</a>       assertEquals(<strong>new</strong> Long(555), value);
<a name="158" href="#158">158</a>    }
<a name="159" href="#159">159</a> 
<a name="160" href="#160">160</a>    <em>/**<em>*</em></em>
<a name="161" href="#161">161</a> <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#getIdColumn(java.lang.Class)}.</em>
<a name="162" href="#162">162</a> <em>    */</em>
<a name="163" href="#163">163</a>    <strong>public</strong> <strong>void</strong> testGetIdColumn() {
<a name="164" href="#164">164</a>       String idc = <strong>null</strong>;
<a name="165" href="#165">165</a> 
<a name="166" href="#166">166</a>       idc = dao.getIdColumn(GenericTestObject.<strong>class</strong>);
<a name="167" href="#167">167</a>       assertNotNull(idc);
<a name="168" href="#168">168</a>       assertEquals(<span class="string">"GTO_ID"</span>, idc);
<a name="169" href="#169">169</a> 
<a name="170" href="#170">170</a>       idc = dao.getIdColumn(GenericTestParentObject.<strong>class</strong>);
<a name="171" href="#171">171</a>       assertNotNull(idc);
<a name="172" href="#172">172</a>       assertEquals(<span class="string">"UID"</span>, idc);
<a name="173" href="#173">173</a>    }
<a name="174" href="#174">174</a> 
<a name="175" href="#175">175</a>    <em>/**<em>*</em></em>
<a name="176" href="#176">176</a> <em>    * Test method for {@link org.sakaiproject.genericdao.springjdbc.JdbcGenericDao#handleTypeReplacements(java.lang.Class, java.lang.String)}.</em>
<a name="177" href="#177">177</a> <em>    */</em>
<a name="178" href="#178">178</a>    <strong>public</strong> <strong>void</strong> testHandleTypeReplacements() {
<a name="179" href="#179">179</a>       String ddl = <strong>null</strong>;
<a name="180" href="#180">180</a> 
<a name="181" href="#181">181</a>       ddl = <span class="string">"create {TABLENAME} ({ID} varchar, other varchar)"</span>;
<a name="182" href="#182">182</a>       ddl = dao.handleTypeReplacements(GenericTestObject.<strong>class</strong>, ddl);
<a name="183" href="#183">183</a>       assertNotNull(ddl);
<a name="184" href="#184">184</a>       assertEquals(<span class="string">"create MY_GENERIC_TEST_OBJECT (GTO_ID varchar, other varchar)"</span>, ddl);
<a name="185" href="#185">185</a> 
<a name="186" href="#186">186</a>       ddl = <span class="string">"create {TABLENAME} ({ID} varchar, other varchar)"</span>;
<a name="187" href="#187">187</a>       ddl = dao.handleTypeReplacements(GenericTestParentObject.<strong>class</strong>, ddl);
<a name="188" href="#188">188</a>       assertNotNull(ddl);
<a name="189" href="#189">189</a>       assertEquals(<span class="string">"create GENERIC_TEST_PARENT_OBJECT (UID varchar, other varchar)"</span>, ddl);
<a name="190" href="#190">190</a> 
<a name="191" href="#191">191</a>       ddl = <span class="string">"create {TABLENAME} ({ID} varchar, other varchar, "</span> +
<a name="192" href="#192">192</a>       <span class="string">"FOREIGN KEY (other) REFERENCES {TABLENAME:"</span>+GenericTestObject.<strong>class</strong>.getName()+<span class="string">"}({ID:"</span>+GenericTestObject.<strong>class</strong>.getName()+<span class="string">"}) )"</span>;
<a name="193" href="#193">193</a>       ddl = dao.handleTypeReplacements(GenericTestParentObject.<strong>class</strong>, ddl);
<a name="194" href="#194">194</a>       assertNotNull(ddl);
<a name="195" href="#195">195</a>       assertEquals(<span class="string">"create GENERIC_TEST_PARENT_OBJECT (UID varchar, other varchar, "</span> +
<a name="196" href="#196">196</a>             <span class="string">"FOREIGN KEY (other) REFERENCES MY_GENERIC_TEST_OBJECT(GTO_ID) )"</span>, ddl);
<a name="197" href="#197">197</a> 
<a name="198" href="#198">198</a>       ddl = <span class="string">"create {TABLENAME} ({ID} varchar, other varchar, "</span> +
<a name="199" href="#199">199</a>       <span class="string">"FOREIGN KEY (other) REFERENCES {TABLENAME:GenericTestObject}({ID:GenericTestObject}) )"</span>;
<a name="200" href="#200">200</a>       ddl = dao.handleTypeReplacements(GenericTestParentObject.<strong>class</strong>, ddl);
<a name="201" href="#201">201</a>       assertNotNull(ddl);
<a name="202" href="#202">202</a>       assertEquals(<span class="string">"create GENERIC_TEST_PARENT_OBJECT (UID varchar, other varchar, "</span> +
<a name="203" href="#203">203</a>             <span class="string">"FOREIGN KEY (other) REFERENCES MY_GENERIC_TEST_OBJECT(GTO_ID) )"</span>, ddl);
<a name="204" href="#204">204</a> 
<a name="205" href="#205">205</a>       ddl = <span class="string">"create {TABLENAME} ({ID} varchar, {COLUMNNAME:title} varchar)"</span>;
<a name="206" href="#206">206</a>       ddl = dao.handleTypeReplacements(GenericTestObject.<strong>class</strong>, ddl);
<a name="207" href="#207">207</a>       assertNotNull(ddl);
<a name="208" href="#208">208</a>       assertEquals(<span class="string">"create MY_GENERIC_TEST_OBJECT (GTO_ID varchar, GTO_TITLE varchar)"</span>, ddl);
<a name="209" href="#209">209</a> 
<a name="210" href="#210">210</a>    }
<a name="211" href="#211">211</a> 
<a name="212" href="#212">212</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

